BusinessUnitGroupEvent

Entity Definition

Logical Name : BusinessUnitGroupEvent
Physical Name : CO_BSN_UN_GP_EV

A reference entity used to identify as business unit specific (store) retailer promotions, holidays, etc. that are intended to motivate customers to purchase products and services. In this context they serve as one aspect of customer behavior (i.e. customer's responsiveness to special events.)

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitGroupID (FK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer BusinessUnitGroupReportingPeriod(CA_PRD_RP_BSN_UN)
BusinessUnitGroupEventID (PK) Token ID for a business unit group event. ID_BSNGP_EV Identity integer
BusinessUnitGroupID (FK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer BusinessUnitGroup(CO_BSNGP)
ReportingPeriodID (FK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer BusinessUnitGroupReportingPeriod(CA_PRD_RP_BSN_UN)
EventNumber Number used to identify an event ID_EV_NMB Identity integer
MajorNonWeatherEventDescription A short narrative description of a major non-weather event that may influence sales activity. Examples of this includ terrorist incidents, fire, riots, and other exceptional conditions unrelated to weather. DE_MJR_NON_WTHR_EV DescriptionShort varchar(255)

Relationships

Parent Entity Verb Phrase Child Entity
BusinessUnitGroupReportingPeriod defines period of BusinessUnitGroupEvent
BusinessUnitGroup emits BusinessUnitGroupEvent

Logical Views containing BusinessUnitGroupEvent

Logical View
Logical 10102 - EnterpriseWeather